CREATE PROCEDURE GetWorkDataByEmployeeInMonth
@companyNo NUMERIC(2,0), @employeeNo NVARCHAR(50), @dateFrom NUMERIC(8,0), @dateTo NUMERIC(8,0)
AS
BEGIN
SELECT WORK_DATA.OVER_TIME, WORK_DATA.WORKING_TIME FROM WORK_DATA WHERE WORK_DATA.COMPANY_NO = @companyNo 
AND WORK_DATA.EMPLOYEE_NO = @employeeNo AND WORK_DATE BETWEEN @dateFrom AND @dateTo
END